package com.chixing.ih.module.programmer.service;

import com.chixing.ih.module.programmer.pojo.Work;

/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: 刘岩
 * Date: 2020-09-26
 * Time: 16:20
 */
public interface IWorkService {

    Work getWork(long programmerId);

    boolean saveWork(Work work);

    boolean saveUserId(long userId);


/**
 * select u.user_id,u.nick_name,u.user_career,u.user_company,any_value(i.image_url) image_url,any_value(w.salary) salary,any_value(w.region_city) region_city,any_value(w.working_day_begin_time) working_day_begin_time ,any_value(w.working_day_endt_time) working_day_endt_time,any_value(w.weekend_working_begin_time) weekend_working_begin_time,any_value(w.weekend_working_end_time) weekend_working_end_time,any_value(truncate(sum(attitude_score+punctuality_score+skill_score)/count(1)/3,1)) star from tbl_user u LEFT JOIN
 *        tbl_work w on u.user_id=w.user_id LEFT JOIN
 * 			 tbl_user_image i ON u.user_id=i.user_id  LEFT JOIN
 *       tbl_evaluate e on w.user_id=e.user_evaluated_id LEFT JOIN
 * 			GROUP BY u.user_id
 * 			 ORDER BY star
 */


}
